package com.ruifu.pls.repository;

import com.ruifu.pls.entity.DocOrderPackingSummary;
import com.ruifu.pls.entity.DocOrderPackingSummaryId;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.util.List;

/**
 * ********************************************************
 * * @desc  ：
 * * @author  ${user}
 * * @date    ${date}
 * * @version v1.0
 * * ${tags}
 * *******************************************************
 */
public interface GGLDocOrderPackingRepository
            extends
    PagingAndSortingRepository<DocOrderPackingSummary,DocOrderPackingSummaryId>, JpaSpecificationExecutor<DocOrderPackingSummary>
    {
        @Query(value="select * from  doc_order_packing_summary  where    ORDERNO=?1",nativeQuery=true)
        public List<DocOrderPackingSummary> findByDocOrderPacking(String orderno);

    }